sqlplus create table

Create Table t_rush_repair(Rush_id number not null,Input_name varchar2 (50 ),Linetype number,Linename varchar2 (50 ),Repair_content varchar2 (200 ),Repair_date date,Memo varchar2 (200)); Comment on column t_rush_repair.rush_id is 'Primary key '; Comment on column t_rush_repair.input_name is 'repair request '; Comment on column t_rush_repair.linetype is 'pipeline type '; Comment on column t_rush_repair.l

In SQLPLUS, you can view the table structure in oracle, modify the table field in SQL statement 1, view the table structure in desc table name 2, modify the table field in SQL statement, and use the rename keyword to modify the fi

/Revoke system privileges grant alter_user to MEP;grant comment any table to MEP;grant create any view to MEP;grant create session to MEP;grant create user to MEP;grant delete any table to MEP;grant drop user to MEP;grant export full database to MEP;grant unlimited tablespac

1. Open the command line window and enter the following command: sqlplus/nolog and press Enter. The prompt SQL>,Enter Conn/As sysdba to log on. If it fails, try again with the password of the conn sys/sys user as sysdba. 2. Check where the current database files are generally stored: input: Select name from V $ datafile;Name--------------------------------------------------------------------------------D: \ oracle \ oradata \ orcl \ system01.dbf D

Tags: oracle tablespace sqlplus Command1. The concept of tablespaceNone of the previously contacted databases have ever heard of the word tablespace, and the table space was found everywhere in the previous time when the Oracle database was seen. So tablespaces should be a very common and important concept in an Oracle database. Tablespace is a logical concept, a logical storage unit. So what is called a lo

Zhangsan.tablenameViii. Transfer of rightsThat is, user a grants permission to B,b to grant the permission of the operation to C again, with the following command:Grant alert table on TableName to Zhangsan with admin option;//keyword with admin optionGrant alert table on TableName to Zhangsan with Grant option;//keyword with GRANT option effect similar to adminNine, the roleA role is a collection of permis

How to create an oracle user through sqlplus 1. Connect to the database for which you want to add a user through the system administratorOr run the following command: connect system/manager @ user_datebase as sysdba; log on to sys to create a user. 2. Create a user and assign PermissionsDrop user asset cascade; delet

Oracle uses sqlplus to query a table space according to the condition. Everyone knows that oracle queries the table space according to the condition, but the query time of the table space seems to be a bit different from that of www.2cto.com: 1 select user_id, username, default_tablespace from dba_users; common conditi

-- Use sqlplus to output data in a table to a text file in a specified format Set term off -- remove Screen Display Set feed off -- remove the number of lines displayed for output Set pagesize 0 -- no page feed Set linesize 2000 -- set the length of the row to ensure that the sum of the length of all the output fields is displayed. Set space off -- set the number of spaces between output Columns Set t

,loc) values (23, ' Zhong ', ' Guo '); sql>select*fromdept; 23 in Guo 10accounting newyork 20research dallas 30 sales chicago 40operations boston 6rowsselected.To view the creation process for a table:Use Dbms_metadata. GET_DDL (' TABLE ', ' table_name ') functionsql>setpagesize0; sql>setlong1000; Sql>selectdbms_metadata. GET_DDL (' TABLE ', ' STUDENT ') fromdual; CREATETABLE "SCOTT". " STUDENT " (" SID "

Use dB; -- List all tables in the current database Show tables; Show tables like's % '; Create Table Name ( Column name type modification constraints, Sid int (3) unsigned zerofill primary key auto_increment Sgender Enum ('male', 'female ', 'confidential') default 'male' ) Engine = MyISAM default charset = utf8; -- Create a

Label:1 CREATE TABLE A like BThis way, when you copy table B to a, the complete field structure and index of table B is copied to table A.2. CREATE TABLE A as SELECT * from BThis method

CREATE TABLE A like BThis way, when you copy table B to a, the complete field structure and index of table B is copied to table A.CREATE TABLE A as SELECT x,x,x,xx from B LIMIT 0This method only copies the field structure of

Table replication in MySQL: create table like and create table as select, tables in mysql Copy codeThe Code is as follows:CREATE TABLE A LIKE B In this way, when table B is copied to

Partitioning1 is suitable for processing large amount of data, such as TB class2 to improve reading and writing and query speed of mega database3 users can create tables by applying partitioning techniques to save data in a partitioned form4 partitioning is the separation of large tables or indexes into relatively small, independently managed parts. The partitioned table does not differ from the unpartition

Copy Code code as follows: CREATE TABLE A like B This way, when you copy table B to a, the complete field structure and index of table B are copied into table A. Copy Code code as follows: CREATE

temporary objects and temporary objects such as temporary stored procedures and temporary functions, temporary objects are stored in tempdb. Temporary tables with a prefix of # are local, so they can only be accessed in the current user session, while temporary tables with a prefix of # are global, so all user sessions can be accessed. A temporary table uses sessions as the boundary. As long as the session for creating a temporary

A, create table-a new table CREATE [Temporary | TEMP] Table Table (Column type[NULL | Not NULL] [UNIQUE] [DEFAULT value][Column_constraint_clause | PRIMARY KEY} [...]][, ... ][, PRIMARY KEY (column [, ...])][, CHECK (condition)][,

Technorati label: before creating a table in PL/SQL, determine whether the table exists. Delete the execution statement of the table if any. Since PL/SQL is used for Oracle client operations, since SQL 2005 was used to execute "before creating a table, determine whether the table